Show AllSets the format of the specified fill to a preset texture.
expression.PresetTextured(PresetTexture)
expression Required. An expression that returns one of the objects in the Applies To list.
PresetTexture Required MsoPresetTexture. The preset texture for the specified fill.
| MsoPresetTexture can be one of these MsoPresetTexture constants. |
| msoPresetTextureMixed |
| msoTextureBouquet |
| msoTextureCanvas |
| msoTextureDenim |
| msoTextureGranite |
| msoTextureMediumWood |
| msoTextureOak |
| msoTexturePapyrus |
| msoTexturePinkTissuePaper |
| msoTextureRecycledPaper |
| msoTextureStationery |
| msoTextureWaterDroplets |
| msoTextureWovenMat |
| msoTextureBlueTissuePaper |
| msoTextureBrownMarble |
| msoTextureCork |
| msoTextureFishFossil |
| msoTextureGreenMarble |
| msoTextureNewsprint |
| msoTexturePaperBag |
| msoTextureParchment |
| msoTexturePurpleMesh |
| msoTextureSand |
| msoTextureWalnut |
| msoTextureWhiteMarble |
This example changes the chart's textured fill format from oak to walnut.
With myChart.ChartArea.Fill
If .Type = msoFillTextured Then
If .TextureType = msoTexturePreset Then
If .PresetTexture = msoTextureOak Then
.PresetTextured msoTextureWalnut
End If
End If
End If
End With